package com.du.stutestsys.config;

import com.baomidou.mybatisplus.core.injector.ISqlInjector;
import com.baomidou.mybatisplus.extension.injector.LogicSqlInjector;
import com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PerformanceInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Profile;
import org.springframework.transaction.annotation.EnableTransactionManagement;

// 扫描我们的mapper文件夹
@MapperScan("com.du.dao")
@EnableTransactionManagement //自动管理事务，默认开启
@Configuration //配置类
public class MyBatisPlusConfig {
    /**
     * 旧版
     */
    //乐观锁
    @Bean
    public OptimisticLockerInterceptor optimisticLockerInterceptor() {
        return new OptimisticLockerInterceptor();
    }

//    /**
//     * 新版
//     */
//    @Bean
//    public MybatisPlusInterceptor mybatisPlusInterceptor() {
//        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
//        mybatisPlusInterceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
//        return mybatisPlusInterceptor;
//    }

    //分页插件
    // 旧版
    @Bean
    public  PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }

//    逻辑删除组件
    @Bean
    public ISqlInjector sqlinjector(){
        System.out.println("加载逻辑删除组件");
            return new LogicSqlInjector();
    }

    /**
     *SQL执行效率插件*/
    @Bean
    @Profile({"dev" ,"test"})//设置dev test环境开启，保证我们的额效率
    public PerformanceInterceptor performanceInterceptor() {
        System.out.println("sql显示");
        PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor();
        performanceInterceptor.setMaxTime(1000); //sql执行时间超过这个就会保错
        performanceInterceptor.setFormat(true); //控制台格式化SQL展示

        return  performanceInterceptor;
    }

}
